SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].ClientesCatInsertCommand
(
	@ID numeric(10, 0),
	@CATEGORIA varchar(50)
)
AS
	SET NOCOUNT OFF;
INSERT INTO [CLIENTES_CAT] ([ID], [CATEGORIA]) VALUES (@ID, @CATEGORIA);
	
SELECT ID, CATEGORIA FROM CLIENTES_CAT WHERE (ID = @ID)
GO
